CLAIMS DENIAL ANALYSIS

Dataset statistics

Number of variables	27
Number of observations	5571
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 MiB
Average record size in memory	247.7 B

Variable types

Numeric	8
Categorical	19

Alerts

`HCPCS_CODE` has a high cardinality: 561 distinct values	High cardinality
`COUNTY` has a high cardinality: 297 distinct values	High cardinality
`CODE` has a high cardinality: 1023 distinct values	High cardinality
`PROCEDURE_CODE` has a high cardinality: 135 distinct values	High cardinality
`PROCEDURE_DESCRIPTION` has a high cardinality: 122 distinct values	High cardinality
`APPROVED_CHARGE` is highly overall correlated with `TOTAL_CHARGES`	High correlation
`REASON_CODE` is highly overall correlated with `CLAIM_STATUS` and 1 other fields	High correlation
`Age` is highly overall correlated with `MEDICARE_STATUS`	High correlation
`TOTAL_CHARGES` is highly overall correlated with `APPROVED_CHARGE`	High correlation
`ENCOUNTER_TYPE` is highly overall correlated with `PLACE_OF_SERVICE_CODE`	High correlation
`CLAIM_STATUS` is highly overall correlated with `REASON_CODE` and 1 other fields	High correlation
`DENIAL_CATEGORY` is highly overall correlated with `REASON_CODE` and 1 other fields	High correlation
`PLACE_OF_SERVICE_CODE` is highly overall correlated with `ENCOUNTER_TYPE` and 1 other fields	High correlation
`MEDICARE_STATUS` is highly overall correlated with `Age`	High correlation
`ADMIT_TYPE_CODE` is highly overall correlated with `PLACE_OF_SERVICE_CODE`	High correlation
`BILL_TYPE_CODE` is highly imbalanced (54.8%)	Imbalance
`RACE` is highly imbalanced (68.3%)	Imbalance
`APPROVED_CHARGE` has 56 (1.0%) zeros	Zeros
`TOTAL_CHARGES` has 56 (1.0%) zeros	Zeros

Reproduction

Analysis started	2023-05-08 16:28:49.120913
Analysis finished	2023-05-08 16:28:58.440178
Duration	9.32 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

APPROVED_CHARGE
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	2867
Distinct (%)	51.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1736.9049

Minimum	-82.7
Maximum	28868.84
Zeros	56
Zeros (%)	1.0%
Negative	28
Negative (%)	0.5%
Memory size	87.0 KiB

Quantile statistics

Minimum	-82.7
5-th percentile	13.86
Q1	53.17
median	252.46
Q3	1764.945
95-th percentile	8062.57
Maximum	28868.84
Range	28951.54
Interquartile range (IQR)	1711.775

Descriptive statistics

Standard deviation	3128.3475
Coefficient of variation (CV)	1.8011047
Kurtosis	12.147919
Mean	1736.9049
Median Absolute Deviation (MAD)	227.35
Skewness	2.9423478
Sum	9676297
Variance	9786558.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	56	1.0%
7902.57	13	0.2%
6667.57	13	0.2%
8062.57	11	0.2%
3659.73	11	0.2%
1251.77	10	0.2%
4.75	10	0.2%
7827.07	10	0.2%
1878.39	10	0.2%
3649.63	10	0.2%
Other values (2857)	5417	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-82.7	2	< 0.1%
-56.55	2	< 0.1%
-37.1	2	< 0.1%
-36.43	2	< 0.1%
-35.34	2	< 0.1%
-35.11	1	< 0.1%
-32.96	1	< 0.1%
-29.51	2	< 0.1%
-27.05	2	< 0.1%
-26.92	1	< 0.1%

Value	Count	Frequency (%)
28868.84	1	< 0.1%
27601.81	4	0.1%
26996.61	2	< 0.1%
26486.41	2	< 0.1%
26052.21	1	< 0.1%
19788.96	3	0.1%
19564.46	2	< 0.1%
19474.36	2	< 0.1%
19398.86	2	< 0.1%
16367.48	2	< 0.1%

REASON_CODE
Real number (ℝ)

Distinct	36
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.439957

Minimum	1
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	22
95-th percentile	115
Maximum	118
Range	117
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	36.800624
Coefficient of variation (CV)	1.8004257
Kurtosis	1.6558012
Mean	20.439957
Median Absolute Deviation (MAD)	0
Skewness	1.8072404
Sum	113871
Variance	1354.2859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
1	3682	66.1%
115	320	5.7%
29	314	5.6%
90	311	5.6%
32	34	0.6%
12	30	0.5%
5	30	0.5%
7	30	0.5%
6	30	0.5%
4	30	0.5%
Other values (26)	760	13.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3682	66.1%
4	30	0.5%
5	30	0.5%
6	30	0.5%
7	30	0.5%
8	29	0.5%
9	30	0.5%
10	30	0.5%
11	30	0.5%
12	30	0.5%

Value	Count	Frequency (%)
118	28	0.5%
117	29	0.5%
116	29	0.5%
115	320	5.7%
114	28	0.5%
112	29	0.5%
111	29	0.5%
90	311	5.6%
76	29	0.5%
74	29	0.5%

Age
Real number (ℝ)

Distinct	60
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.418955

Minimum	19
Maximum	104
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	19
5-th percentile	55
Q1	71
median	76
Q3	84
95-th percentile	94
Maximum	104
Range	85
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	12.533418
Coefficient of variation (CV)	0.16400928
Kurtosis	2.8298925
Mean	76.418955
Median Absolute Deviation (MAD)	7
Skewness	-0.99749688
Sum	425730
Variance	157.08656
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	386	6.9%
72	369	6.6%
73	334	6.0%
79	283	5.1%
90	235	4.2%
77	217	3.9%
84	212	3.8%
75	205	3.7%
71	205	3.7%
69	204	3.7%
Other values (50)	2921	52.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	30	0.5%
38	80	1.4%
39	19	0.3%
42	35	0.6%
43	15	0.3%
44	9	0.2%
45	18	0.3%
47	2	< 0.1%
49	13	0.2%
50	4	0.1%

Value	Count	Frequency (%)
104	38	0.7%
101	22	0.4%
100	8	0.1%
99	71	1.3%
98	30	0.5%
97	7	0.1%
96	33	0.6%
95	34	0.6%
94	114	2.0%
93	78	1.4%

SERVICE_UNIT_QUANTITY
Real number (ℝ)

Distinct	98
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8427571

Minimum	0
Maximum	510
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	12
Maximum	510
Range	510
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20.989115
Coefficient of variation (CV)	4.3341251
Kurtosis	131.2897
Mean	4.8427571
Median Absolute Deviation (MAD)	0
Skewness	9.6802388
Sum	26979
Variance	440.54295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	4399	79.0%
2	399	7.2%
3	142	2.5%
4	135	2.4%
5	51	0.9%
6	50	0.9%
20	29	0.5%
100	29	0.5%
10	28	0.5%
8	27	0.5%
Other values (88)	282	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	4399	79.0%
2	399	7.2%
3	142	2.5%
4	135	2.4%
5	51	0.9%
6	50	0.9%
7	24	0.4%
8	27	0.5%
9	10	0.2%

Value	Count	Frequency (%)
510	1	< 0.1%
340	1	< 0.1%
321	1	< 0.1%
300	1	< 0.1%
296	1	< 0.1%
280	1	< 0.1%
266	1	< 0.1%
244	1	< 0.1%
240	1	< 0.1%
205	1	< 0.1%

TOTAL_CHARGES
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3155
Distinct (%)	56.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1783.3414

Minimum	-36.43
Maximum	28868.84
Zeros	56
Zeros (%)	1.0%
Negative	8
Negative (%)	0.1%
Memory size	87.0 KiB

Quantile statistics

Minimum	-36.43
5-th percentile	27.84
Q1	108.62
median	343.33
Q3	1786.52
95-th percentile	8157.07
Maximum	28868.84
Range	28905.27
Interquartile range (IQR)	1677.9

Descriptive statistics

Standard deviation	3116.1498
Coefficient of variation (CV)	1.7473658
Kurtosis	12.295841
Mean	1783.3414
Median Absolute Deviation (MAD)	296.8
Skewness	2.9589874
Sum	9934995
Variance	9710389.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	56	1.0%
7902.57	13	0.2%
6667.57	13	0.2%
8062.57	11	0.2%
3659.73	11	0.2%
3649.63	10	0.2%
1878.39	10	0.2%
1192.27	9	0.2%
9422.86	9	0.2%
8217.17	9	0.2%
Other values (3145)	5420	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-36.43	2	< 0.1%
-35.11	1	< 0.1%
-32.96	1	< 0.1%
-26.92	1	< 0.1%
-25.92	1	< 0.1%
-24.3	1	< 0.1%
-21.77	1	< 0.1%
0	56	1.0%
0.35	1	< 0.1%
2.47	1	< 0.1%

Value	Count	Frequency (%)
28868.84	1	< 0.1%
27782.81	2	< 0.1%
27601.81	2	< 0.1%
26996.61	2	< 0.1%
26486.41	2	< 0.1%
26052.21	1	< 0.1%
19788.96	3	0.1%
19564.46	2	< 0.1%
19474.36	2	< 0.1%
19398.86	2	< 0.1%

BILL_TYPE_CODE
Categorical

Distinct	28
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

131	3381
111	735
141	391
13I	254
851	243
Other values (23)	567

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	16713
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	131
2nd row	131
3rd row	131
4th row	131
5th row	131

Common Values

Value	Count	Frequency (%)
131	3381	60.7%
111	735	13.2%
141	391	7.0%
13I	254	4.6%
851	243	4.4%
137	208	3.7%
117	45	0.8%
133	40	0.7%
132	40	0.7%
11I	34	0.6%
Other values (18)	200	3.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
131	3381	60.7%
111	735	13.2%
141	391	7.0%
13i	254	4.6%
851	243	4.4%
137	208	3.7%
117	45	0.8%
133	40	0.7%
132	40	0.7%
11i	34	0.6%
Other values (18)	200	3.6%

Most occurring characters

Value	Count	Frequency (%)
1	10851	64.9%
3	4032	24.1%
4	413	2.5%
7	336	2.0%
8	326	2.0%
I	319	1.9%
5	301	1.8%
2	89	0.5%
0	26	0.2%
9	20	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16394	98.1%
Uppercase Letter	319	1.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	10851	66.2%
3	4032	24.6%
4	413	2.5%
7	336	2.0%
8	326	2.0%
5	301	1.8%
2	89	0.5%
0	26	0.2%
9	20	0.1%

Uppercase Letter

Value	Count	Frequency (%)
I	319	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	16394	98.1%
Latin	319	1.9%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	10851	66.2%
3	4032	24.6%
4	413	2.5%
7	336	2.0%
8	326	2.0%
5	301	1.8%
2	89	0.5%
0	26	0.2%
9	20	0.1%

Latin

Value	Count	Frequency (%)
I	319	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16713	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	10851	64.9%
3	4032	24.1%
4	413	2.5%
7	336	2.0%
8	326	2.0%
I	319	1.9%
5	301	1.8%
2	89	0.5%
0	26	0.2%
9	20	0.1%

HCPCS_CODE
Categorical

Distinct	561
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

36415	324
G0463	228
80053	176
85025	173
Q0510	149
Other values (556)	4521

Length

Max length	6
Median length	5
Mean length	5.0001795
Min length	1

Characters and Unicode

Total characters	27856
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	173 ?
Unique (%)	3.1%

Sample

1st row	82306
2nd row	J1644
3rd row	76642
4th row	85610
5th row	G0463

Common Values

Value	Count	Frequency (%)
36415	324	5.8%
G0463	228	4.1%
80053	176	3.2%
85025	173	3.1%
Q0510	149	2.7%
80061	132	2.4%
80048	118	2.1%
84443	110	2.0%
A9270	109	2.0%
97110	91	1.6%
Other values (551)	3961	71.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
36415	324	5.8%
g0463	228	4.1%
80053	176	3.2%
85025	173	3.1%
q0510	149	2.7%
80061	132	2.4%
80048	118	2.1%
84443	110	2.0%
a9270	109	2.0%
97110	91	1.6%
Other values (551)	3961	71.1%

Most occurring characters

Value	Count	Frequency (%)
0	4912	17.6%
8	3275	11.8%
3	2551	9.2%
9	2404	8.6%
5	2356	8.5%
1	2344	8.4%
4	2287	8.2%
7	2151	7.7%
6	2118	7.6%
2	1959	7.0%
Other values (12)	1499	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	26357	94.6%
Uppercase Letter	1499	5.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	481	32.1%
A	300	20.0%
J	278	18.5%
Q	245	16.3%
C	79	5.3%
P	53	3.5%
Z	38	2.5%
S	10	0.7%
L	9	0.6%
V	3	0.2%
Other values (2)	3	0.2%

Decimal Number

Value	Count	Frequency (%)
0	4912	18.6%
8	3275	12.4%
3	2551	9.7%
9	2404	9.1%
5	2356	8.9%
1	2344	8.9%
4	2287	8.7%
7	2151	8.2%
6	2118	8.0%
2	1959	7.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	26357	94.6%
Latin	1499	5.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	481	32.1%
A	300	20.0%
J	278	18.5%
Q	245	16.3%
C	79	5.3%
P	53	3.5%
Z	38	2.5%
S	10	0.7%
L	9	0.6%
V	3	0.2%
Other values (2)	3	0.2%

Common

Value	Count	Frequency (%)
0	4912	18.6%
8	3275	12.4%
3	2551	9.7%
9	2404	9.1%
5	2356	8.9%
1	2344	8.9%
4	2287	8.7%
7	2151	8.2%
6	2118	8.0%
2	1959	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4912	17.6%
8	3275	11.8%
3	2551	9.2%
9	2404	8.6%
5	2356	8.5%
1	2344	8.4%
4	2287	8.2%
7	2151	7.7%
6	2118	7.6%
2	1959	7.0%
Other values (12)	1499	5.4%

GENDER
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

female	3289
male	2282

Length

Max length	6
Median length	6
Mean length	5.1807575
Min length	4

Characters and Unicode

Total characters	28862
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	male
2nd row	female
3rd row	female
4th row	male
5th row	male

Common Values

Value	Count	Frequency (%)
female	3289	59.0%
male	2282	41.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	3289	59.0%
male	2282	41.0%

Most occurring characters

Value	Count	Frequency (%)
e	8860	30.7%
m	5571	19.3%
a	5571	19.3%
l	5571	19.3%
f	3289	11.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28862	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8860	30.7%
m	5571	19.3%
a	5571	19.3%
l	5571	19.3%
f	3289	11.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	28862	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8860	30.7%
m	5571	19.3%
a	5571	19.3%
l	5571	19.3%
f	3289	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28862	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8860	30.7%
m	5571	19.3%
a	5571	19.3%
l	5571	19.3%
f	3289	11.4%

RACE
Categorical

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

white	4710
black	519
hispanic	141
other	76
asian	63
Other values (2)	62

Length

Max length	21
Median length	5
Mean length	5.1057261
Min length	5

Characters and Unicode

Total characters	28444
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	white
2nd row	white
3rd row	white
4th row	white
5th row	white

Common Values

Value	Count	Frequency (%)
white	4710	84.5%
black	519	9.3%
hispanic	141	2.5%
other	76	1.4%
asian	63	1.1%
unknown	59	1.1%
north american native	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
white	4710	84.5%
black	519	9.3%
hispanic	141	2.5%
other	76	1.4%
asian	63	1.1%
unknown	59	1.1%
north	3	0.1%
american	3	0.1%
native	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	5061	17.8%
h	4930	17.3%
t	4792	16.8%
e	4792	16.8%
w	4769	16.8%
a	795	2.8%
c	663	2.3%
k	578	2.0%
l	519	1.8%
b	519	1.8%
Other values (9)	1026	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28438	> 99.9%
Space Separator	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	5061	17.8%
h	4930	17.3%
t	4792	16.9%
e	4792	16.9%
w	4769	16.8%
a	795	2.8%
c	663	2.3%
k	578	2.0%
l	519	1.8%
b	519	1.8%
Other values (8)	1020	3.6%

Space Separator

Value	Count	Frequency (%)
	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	28438	> 99.9%
Common	6	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	5061	17.8%
h	4930	17.3%
t	4792	16.9%
e	4792	16.9%
w	4769	16.8%
a	795	2.8%
c	663	2.3%
k	578	2.0%
l	519	1.8%
b	519	1.8%
Other values (8)	1020	3.6%

Common

Value	Count	Frequency (%)
	6	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28444	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	5061	17.8%
h	4930	17.3%
t	4792	16.8%
e	4792	16.8%
w	4769	16.8%
a	795	2.8%
c	663	2.3%
k	578	2.0%
l	519	1.8%
b	519	1.8%
Other values (9)	1026	3.6%

STATE
Categorical

Distinct	48
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

California	412
Texas	410
Florida	406
Michigan	332
Indiana	278
Other values (43)	3733

Length

Max length	14
Median length	12
Mean length	8.3819781
Min length	2

Characters and Unicode

Total characters	46696
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	North Carolina
2nd row	Utah
3rd row	Delaware
4th row	Connecticut
5th row	Iowa

Common Values

Value	Count	Frequency (%)
California	412	7.4%
Texas	410	7.4%
Florida	406	7.3%
Michigan	332	6.0%
Indiana	278	5.0%
Ohio	235	4.2%
Pennsylvania	230	4.1%
North Carolina	211	3.8%
New York	198	3.6%
New Jersey	181	3.2%
Other values (38)	2678	48.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	425	6.7%
california	412	6.5%
texas	410	6.4%
florida	406	6.4%
michigan	332	5.2%
carolina	312	4.9%
indiana	278	4.4%
ohio	235	3.7%
pennsylvania	230	3.6%
north	211	3.3%
Other values (41)	3118	49.0%

Most occurring characters

Value	Count	Frequency (%)
a	6050	13.0%
i	5421	11.6%
n	4441	9.5%
s	3453	7.4%
o	3346	7.2%
e	2901	6.2%
r	2409	5.2%
l	2044	4.4%
h	1457	3.1%
t	1263	2.7%
Other values (36)	13911	29.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	39508	84.6%
Uppercase Letter	6390	13.7%
Space Separator	798	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6050	15.3%
i	5421	13.7%
n	4441	11.2%
s	3453	8.7%
o	3346	8.5%
e	2901	7.3%
r	2409	6.1%
l	2044	5.2%
h	1457	3.7%
t	1263	3.2%
Other values (14)	6723	17.0%

Uppercase Letter

Value	Count	Frequency (%)
M	927	14.5%
C	845	13.2%
N	757	11.8%
I	618	9.7%
T	547	8.6%
O	447	7.0%
F	406	6.4%
W	318	5.0%
P	230	3.6%
Y	198	3.1%
Other values (11)	1097	17.2%

Space Separator

Value	Count	Frequency (%)
	798	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45898	98.3%
Common	798	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6050	13.2%
i	5421	11.8%
n	4441	9.7%
s	3453	7.5%
o	3346	7.3%
e	2901	6.3%
r	2409	5.2%
l	2044	4.5%
h	1457	3.2%
t	1263	2.8%
Other values (35)	13113	28.6%

Common

Value	Count	Frequency (%)
	798	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46696	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6050	13.0%
i	5421	11.6%
n	4441	9.5%
s	3453	7.4%
o	3346	7.2%
e	2901	6.2%
r	2409	5.2%
l	2044	4.4%
h	1457	3.1%
t	1263	2.7%
Other values (36)	13911	29.8%

COUNTY
Categorical

Distinct	297
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

Suffolk	107
Bailey	106
Cumberland	103
Palm Beach	98
La Porte	93
Other values (292)	5064

Length

Max length	19
Median length	15
Mean length	7.4799856
Min length	3

Characters and Unicode

Total characters	41671
Distinct characters	51
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.2%

Sample

1st row	Cherokee
2nd row	Summit
3rd row	New Castle
4th row	Fairfield
5th row	Pottawattamie

Common Values

Value	Count	Frequency (%)
Suffolk	107	1.9%
Bailey	106	1.9%
Cumberland	103	1.8%
Palm Beach	98	1.8%
La Porte	93	1.7%
Middlesex	86	1.5%
Fairfield	81	1.5%
King	80	1.4%
San Diego	79	1.4%
Warrick	73	1.3%
Other values (287)	4665	83.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	154	2.4%
suffolk	107	1.7%
bailey	106	1.7%
cumberland	103	1.6%
la	102	1.6%
beach	101	1.6%
palm	98	1.5%
lake	96	1.5%
porte	93	1.4%
middlesex	86	1.3%
Other values (308)	5368	83.7%

Most occurring characters

Value	Count	Frequency (%)
a	4364	10.5%
e	4093	9.8%
o	3134	7.5%
n	2746	6.6%
r	2612	6.3%
l	2458	5.9%
i	2338	5.6%
t	2013	4.8%
s	1697	4.1%
u	1102	2.6%
Other values (41)	15114	36.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34420	82.6%
Uppercase Letter	6398	15.4%
Space Separator	843	2.0%
Dash Punctuation	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4364	12.7%
e	4093	11.9%
o	3134	9.1%
n	2746	8.0%
r	2612	7.6%
l	2458	7.1%
i	2338	6.8%
t	2013	5.8%
s	1697	4.9%
u	1102	3.2%
Other values (15)	7863	22.8%

Uppercase Letter

Value	Count	Frequency (%)
C	867	13.6%
S	774	12.1%
B	584	9.1%
M	553	8.6%
P	549	8.6%
W	434	6.8%
L	422	6.6%
D	375	5.9%
K	214	3.3%
H	210	3.3%
Other values (14)	1416	22.1%

Space Separator

Value	Count	Frequency (%)
	843	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40818	98.0%
Common	853	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4364	10.7%
e	4093	10.0%
o	3134	7.7%
n	2746	6.7%
r	2612	6.4%
l	2458	6.0%
i	2338	5.7%
t	2013	4.9%
s	1697	4.2%
u	1102	2.7%
Other values (39)	14261	34.9%

Common

Value	Count	Frequency (%)
	843	98.8%
-	10	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41671	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4364	10.5%
e	4093	9.8%
o	3134	7.5%
n	2746	6.6%
r	2612	6.3%
l	2458	5.9%
i	2338	5.6%
t	2013	4.8%
s	1697	4.1%
u	1102	2.6%
Other values (41)	15114	36.3%

CODE
Categorical

Distinct	1023
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

I10	336
E785	185
I2510	157
E039	86
R079	84
Other values (1018)	4723

Length

Max length	7
Median length	6
Mean length	4.4763956
Min length	3

Characters and Unicode

Total characters	24938
Distinct characters	32
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	405 ?
Unique (%)	7.3%

Sample

1st row	G9340
2nd row	E1142
3rd row	I480
4th row	I10
5th row	I255

Common Values

Value	Count	Frequency (%)
I10	336	6.0%
E785	185	3.3%
I2510	157	2.8%
E039	86	1.5%
R079	84	1.5%
K219	80	1.4%
Z79899	70	1.3%
E119	68	1.2%
Z7982	60	1.1%
Z1231	60	1.1%
Other values (1013)	4385	78.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
i10	336	6.0%
e785	185	3.3%
i2510	157	2.8%
e039	86	1.5%
r079	84	1.5%
k219	80	1.4%
z79899	70	1.3%
e119	68	1.2%
z1231	60	1.1%
z7982	60	1.1%
Other values (1013)	4385	78.7%

Most occurring characters

Value	Count	Frequency (%)
1	3202	12.8%
0	2980	11.9%
9	2716	10.9%
8	1964	7.9%
2	1835	7.4%
5	1659	6.7%
7	1425	5.7%
4	1260	5.1%
3	1216	4.9%
I	1077	4.3%
Other values (22)	5604	22.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	19192	77.0%
Uppercase Letter	5746	23.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	1077	18.7%
R	978	17.0%
Z	903	15.7%
E	693	12.1%
M	440	7.7%
K	332	5.8%
N	250	4.4%
J	203	3.5%
D	140	2.4%
G	138	2.4%
Other values (12)	592	10.3%

Decimal Number

Value	Count	Frequency (%)
1	3202	16.7%
0	2980	15.5%
9	2716	14.2%
8	1964	10.2%
2	1835	9.6%
5	1659	8.6%
7	1425	7.4%
4	1260	6.6%
3	1216	6.3%
6	935	4.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	19192	77.0%
Latin	5746	23.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	1077	18.7%
R	978	17.0%
Z	903	15.7%
E	693	12.1%
M	440	7.7%
K	332	5.8%
N	250	4.4%
J	203	3.5%
D	140	2.4%
G	138	2.4%
Other values (12)	592	10.3%

Common

Value	Count	Frequency (%)
1	3202	16.7%
0	2980	15.5%
9	2716	14.2%
8	1964	10.2%
2	1835	9.6%
5	1659	8.6%
7	1425	7.4%
4	1260	6.6%
3	1216	6.3%
6	935	4.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3202	12.8%
0	2980	11.9%
9	2716	10.9%
8	1964	7.9%
2	1835	7.4%
5	1659	6.7%
7	1425	5.7%
4	1260	5.1%
3	1216	4.9%
I	1077	4.3%
Other values (22)	5604	22.5%

PRESENT_ON_ADMIT
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

0	2341
N	1765
Y	1465

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5571
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Y
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	2341	42.0%
N	1765	31.7%
Y	1465	26.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	2341	42.0%
n	1765	31.7%
y	1465	26.3%

Most occurring characters

Value	Count	Frequency (%)
0	2341	42.0%
N	1765	31.7%
Y	1465	26.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3230	58.0%
Decimal Number	2341	42.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	1765	54.6%
Y	1465	45.4%

Decimal Number

Value	Count	Frequency (%)
0	2341	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3230	58.0%
Common	2341	42.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	1765	54.6%
Y	1465	45.4%

Common

Value	Count	Frequency (%)
0	2341	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2341	42.0%
N	1765	31.7%
Y	1465	26.3%

DUAL_STATUS
Categorical

Distinct	10
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

5	773
3	722
1	635
8	630
0	607
Other values (5)	2204

Length

Max length	3
Median length	1
Mean length	1.0107701
Min length	1

Characters and Unicode

Total characters	5631
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	0
3rd row	4
4th row	2
5th row	7

Common Values

Value	Count	Frequency (%)
5	773	13.9%
3	722	13.0%
1	635	11.4%
8	630	11.3%
0	607	10.9%
6	594	10.7%
7	583	10.5%
2	546	9.8%
4	451	8.1%
Yes	30	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	773	13.9%
3	722	13.0%
1	635	11.4%
8	630	11.3%
0	607	10.9%
6	594	10.7%
7	583	10.5%
2	546	9.8%
4	451	8.1%
yes	30	0.5%

Most occurring characters

Value	Count	Frequency (%)
5	773	13.7%
3	722	12.8%
1	635	11.3%
8	630	11.2%
0	607	10.8%
6	594	10.5%
7	583	10.4%
2	546	9.7%
4	451	8.0%
Y	30	0.5%
Other values (2)	60	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5541	98.4%
Lowercase Letter	60	1.1%
Uppercase Letter	30	0.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	773	14.0%
3	722	13.0%
1	635	11.5%
8	630	11.4%
0	607	11.0%
6	594	10.7%
7	583	10.5%
2	546	9.9%
4	451	8.1%

Lowercase Letter

Value	Count	Frequency (%)
e	30	50.0%
s	30	50.0%

Uppercase Letter

Value	Count	Frequency (%)
Y	30	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5541	98.4%
Latin	90	1.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	773	14.0%
3	722	13.0%
1	635	11.5%
8	630	11.4%
0	607	11.0%
6	594	10.7%
7	583	10.5%
2	546	9.9%
4	451	8.1%

Latin

Value	Count	Frequency (%)
Y	30	33.3%
e	30	33.3%
s	30	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5631	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	773	13.7%
3	722	12.8%
1	635	11.3%
8	630	11.2%
0	607	10.8%
6	594	10.5%
7	583	10.4%
2	546	9.7%
4	451	8.0%
Y	30	0.5%
Other values (2)	60	1.1%

ENCOUNTER_TYPE
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

Outpatient	1452
Other	1178
Emergency Department	1166
Skilled Nursing Facility	901
Acute Inpatient	874

Length

Max length	24
Median length	15
Mean length	14.084365
Min length	5

Characters and Unicode

Total characters	78464
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Acute Inpatient
2nd row	Other
3rd row	Emergency Department
4th row	Other
5th row	Other

Common Values

Value	Count	Frequency (%)
Outpatient	1452	26.1%
Other	1178	21.1%
Emergency Department	1166	20.9%
Skilled Nursing Facility	901	16.2%
Acute Inpatient	874	15.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
outpatient	1452	15.4%
other	1178	12.5%
emergency	1166	12.4%
department	1166	12.4%
skilled	901	9.6%
nursing	901	9.6%
facility	901	9.6%
acute	874	9.3%
inpatient	874	9.3%

Most occurring characters

Value	Count	Frequency (%)
t	11389	14.5%
e	9943	12.7%
n	6433	8.2%
i	5930	7.6%
r	4411	5.6%
a	4393	5.6%
	3842	4.9%
p	3492	4.5%
u	3227	4.1%
c	2941	3.7%
Other values (16)	22463	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	65209	83.1%
Uppercase Letter	9413	12.0%
Space Separator	3842	4.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	11389	17.5%
e	9943	15.2%
n	6433	9.9%
i	5930	9.1%
r	4411	6.8%
a	4393	6.7%
p	3492	5.4%
u	3227	4.9%
c	2941	4.5%
l	2703	4.1%
Other values (7)	10347	15.9%

Uppercase Letter

Value	Count	Frequency (%)
O	2630	27.9%
E	1166	12.4%
D	1166	12.4%
S	901	9.6%
N	901	9.6%
F	901	9.6%
A	874	9.3%
I	874	9.3%

Space Separator

Value	Count	Frequency (%)
	3842	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	74622	95.1%
Common	3842	4.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	11389	15.3%
e	9943	13.3%
n	6433	8.6%
i	5930	7.9%
r	4411	5.9%
a	4393	5.9%
p	3492	4.7%
u	3227	4.3%
c	2941	3.9%
l	2703	3.6%
Other values (15)	19760	26.5%

Common

Value	Count	Frequency (%)
	3842	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	78464	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	11389	14.5%
e	9943	12.7%
n	6433	8.2%
i	5930	7.6%
r	4411	5.6%
a	4393	5.6%
	3842	4.9%
p	3492	4.5%
u	3227	4.1%
c	2941	3.7%
Other values (16)	22463	28.6%

CLAIM_STATUS
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

Approved	3682
Denied	1889

Length

Max length	8
Median length	8
Mean length	7.3218453
Min length	6

Characters and Unicode

Total characters	40790
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Denied
2nd row	Denied
3rd row	Denied
4th row	Denied
5th row	Denied

Common Values

Value	Count	Frequency (%)
Approved	3682	66.1%
Denied	1889	33.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	3682	66.1%
denied	1889	33.9%

Most occurring characters

Value	Count	Frequency (%)
e	7460	18.3%
p	7364	18.1%
d	5571	13.7%
A	3682	9.0%
r	3682	9.0%
o	3682	9.0%
v	3682	9.0%
D	1889	4.6%
n	1889	4.6%
i	1889	4.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35219	86.3%
Uppercase Letter	5571	13.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	7460	21.2%
p	7364	20.9%
d	5571	15.8%
r	3682	10.5%
o	3682	10.5%
v	3682	10.5%
n	1889	5.4%
i	1889	5.4%

Uppercase Letter

Value	Count	Frequency (%)
A	3682	66.1%
D	1889	33.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40790	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	7460	18.3%
p	7364	18.1%
d	5571	13.7%
A	3682	9.0%
r	3682	9.0%
o	3682	9.0%
v	3682	9.0%
D	1889	4.6%
n	1889	4.6%
i	1889	4.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40790	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	7460	18.3%
p	7364	18.1%
d	5571	13.7%
A	3682	9.0%
r	3682	9.0%
o	3682	9.0%
v	3682	9.0%
D	1889	4.6%
n	1889	4.6%
i	1889	4.6%

PAYERS
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

BCBS	1680
Medicare	1394
Aetna	951
Cigna	718
Humana	552

Length

Max length	8
Median length	6
Mean length	5.4491115
Min length	3

Characters and Unicode

Total characters	30357
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Medicare
2nd row	Medicare
3rd row	Humana
4th row	Medicare
5th row	Cigna

Common Values

Value	Count	Frequency (%)
BCBS	1680	30.2%
Medicare	1394	25.0%
Aetna	951	17.1%
Cigna	718	12.9%
Humana	552	9.9%
UHG	276	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
bcbs	1680	30.2%
medicare	1394	25.0%
aetna	951	17.1%
cigna	718	12.9%
humana	552	9.9%
uhg	276	5.0%

Most occurring characters

Value	Count	Frequency (%)
a	4167	13.7%
e	3739	12.3%
B	3360	11.1%
C	2398	7.9%
n	2221	7.3%
i	2112	7.0%
S	1680	5.5%
r	1394	4.6%
c	1394	4.6%
d	1394	4.6%
Other values (9)	6498	21.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	19194	63.2%
Uppercase Letter	11163	36.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4167	21.7%
e	3739	19.5%
n	2221	11.6%
i	2112	11.0%
r	1394	7.3%
c	1394	7.3%
d	1394	7.3%
t	951	5.0%
g	718	3.7%
u	552	2.9%

Uppercase Letter

Value	Count	Frequency (%)
B	3360	30.1%
C	2398	21.5%
S	1680	15.0%
M	1394	12.5%
A	951	8.5%
H	828	7.4%
U	276	2.5%
G	276	2.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	30357	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4167	13.7%
e	3739	12.3%
B	3360	11.1%
C	2398	7.9%
n	2221	7.3%
i	2112	7.0%
S	1680	5.5%
r	1394	4.6%
c	1394	4.6%
d	1394	4.6%
Other values (9)	6498	21.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30357	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4167	13.7%
e	3739	12.3%
B	3360	11.1%
C	2398	7.9%
n	2221	7.3%
i	2112	7.0%
S	1680	5.5%
r	1394	4.6%
c	1394	4.6%
d	1394	4.6%
Other values (9)	6498	21.4%

DENIAL_CATEGORY
Categorical

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

NOT_APPLICABLE	3682
Prior Authorization	1176
Eligibility	414
Coding Error	207
Benefit Exhausted	63

Length

Max length	19
Median length	14
Mean length	14.750494
Min length	6

Characters and Unicode

Total characters	82175
Distinct characters	30
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Eligibility
2nd row	Coding Error
3rd row	Prior Authorization
4th row	Benefit Exhausted
5th row	Coding Error

Common Values

Value	Count	Frequency (%)
NOT_APPLICABLE	3682	66.1%
Prior Authorization	1176	21.1%
Eligibility	414	7.4%
Coding Error	207	3.7%
Benefit Exhausted	63	1.1%
Others	29	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
not_applicable	3682	52.5%
prior	1176	16.8%
authorization	1176	16.8%
eligibility	414	5.9%
coding	207	2.9%
error	207	2.9%
benefit	63	0.9%
exhausted	63	0.9%
others	29	0.4%

Most occurring characters

Value	Count	Frequency (%)
A	8540	10.4%
P	8540	10.4%
L	7364	9.0%
i	5454	6.6%
E	4366	5.3%
r	4178	5.1%
o	3942	4.8%
C	3889	4.7%
B	3745	4.6%
O	3711	4.5%
Other values (20)	28446	34.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	51201	62.3%
Lowercase Letter	25846	31.5%
Connector Punctuation	3682	4.5%
Space Separator	1446	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	5454	21.1%
r	4178	16.2%
o	3942	15.3%
t	2921	11.3%
n	1446	5.6%
h	1268	4.9%
a	1239	4.8%
u	1239	4.8%
z	1176	4.6%
l	828	3.2%
Other values (8)	2155	8.3%

Uppercase Letter

Value	Count	Frequency (%)
A	8540	16.7%
P	8540	16.7%
L	7364	14.4%
E	4366	8.5%
C	3889	7.6%
B	3745	7.3%
O	3711	7.2%
N	3682	7.2%
I	3682	7.2%
T	3682	7.2%

Connector Punctuation

Value	Count	Frequency (%)
_	3682	100.0%

Space Separator

Value	Count	Frequency (%)
	1446	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	77047	93.8%
Common	5128	6.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	8540	11.1%
P	8540	11.1%
L	7364	9.6%
i	5454	7.1%
E	4366	5.7%
r	4178	5.4%
o	3942	5.1%
C	3889	5.0%
B	3745	4.9%
O	3711	4.8%
Other values (18)	23318	30.3%

Common

Value	Count	Frequency (%)
_	3682	71.8%
	1446	28.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	82175	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	8540	10.4%
P	8540	10.4%
L	7364	9.0%
i	5454	6.6%
E	4366	5.3%
r	4178	5.1%
o	3942	4.8%
C	3889	4.7%
B	3745	4.6%
O	3711	4.5%
Other values (20)	28446	34.6%

PROCEDURE_CODE
Categorical

Distinct	135
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

03CL0ZZ	200
0T768DZ	185
5A1945Z	179
0D9670Z	178
03CK0ZZ	171
Other values (130)	4658

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	38997
Distinct characters	34
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21 ?
Unique (%)	0.4%

Sample

1st row	0RGA071
2nd row	0W3P8ZZ
3rd row	0D9670Z
4th row	4A023N7
5th row	06BQ4ZZ

Common Values

Value	Count	Frequency (%)
03CL0ZZ	200	3.6%
0T768DZ	185	3.3%
5A1945Z	179	3.2%
0D9670Z	178	3.2%
03CK0ZZ	171	3.1%
027034Z	143	2.6%
B548ZZA	135	2.4%
8E0W4CZ	135	2.4%
0SPC08Z	130	2.3%
0SB20ZZ	126	2.3%
Other values (125)	3989	71.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
03cl0zz	200	3.6%
0t768dz	185	3.3%
5a1945z	179	3.2%
0d9670z	178	3.2%
03ck0zz	171	3.1%
027034z	143	2.6%
b548zza	135	2.4%
8e0w4cz	135	2.4%
0spc08z	130	2.3%
0sb20zz	126	2.3%
Other values (125)	3989	71.6%

Most occurring characters

Value	Count	Frequency (%)
Z	6989	17.9%
0	6504	16.7%
3	2972	7.6%
4	2068	5.3%
B	1882	4.8%
2	1804	4.6%
1	1664	4.3%
8	1629	4.2%
5	1457	3.7%
A	1424	3.7%
Other values (24)	10604	27.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20930	53.7%
Uppercase Letter	18067	46.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
Z	6989	38.7%
B	1882	10.4%
A	1424	7.9%
D	1089	6.0%
C	860	4.8%
S	687	3.8%
X	574	3.2%
E	512	2.8%
P	477	2.6%
T	457	2.5%
Other values (14)	3116	17.2%

Decimal Number

Value	Count	Frequency (%)
0	6504	31.1%
3	2972	14.2%
4	2068	9.9%
2	1804	8.6%
1	1664	8.0%
8	1629	7.8%
5	1457	7.0%
7	1262	6.0%
9	820	3.9%
6	750	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	20930	53.7%
Latin	18067	46.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
Z	6989	38.7%
B	1882	10.4%
A	1424	7.9%
D	1089	6.0%
C	860	4.8%
S	687	3.8%
X	574	3.2%
E	512	2.8%
P	477	2.6%
T	457	2.5%
Other values (14)	3116	17.2%

Common

Value	Count	Frequency (%)
0	6504	31.1%
3	2972	14.2%
4	2068	9.9%
2	1804	8.6%
1	1664	8.0%
8	1629	7.8%
5	1457	7.0%
7	1262	6.0%
9	820	3.9%
6	750	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
Z	6989	17.9%
0	6504	16.7%
3	2972	7.6%
4	2068	5.3%
B	1882	4.8%
2	1804	4.6%
1	1664	4.3%
8	1629	4.2%
5	1457	3.7%
A	1424	3.7%
Other values (24)	10604	27.2%

PROCEDURE_DESCRIPTION
Categorical

Distinct	122
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

Precertification/authorization/notification/pre-treatment absent.	320
Plan procedures not followed.	314
Patient refused the service/procedure.	311
Dilation of Right Ureter with Intraluminal Device, Endo	159
Extirpation of Matter from L Int Carotid, Open Approach	152
Other values (117)	4315

Length

Max length	116
Median length	68
Mean length	51.65105
Min length	27

Characters and Unicode

Total characters	287748
Distinct characters	63
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	Charges do not meet qualifications for emergent/urgent care.
2nd row	Processed in Excess of charges.
3rd row	Lifetime benefit maximum has been reached for this service/benefit category.
4th row	ESRD network support adjustment.
5th row	The procedure code is inconsistent with the provider type/specialty (taxonomy).

Common Values

Value	Count	Frequency (%)
Precertification/authorization/notification/pre-treatment absent.	320	5.7%
Plan procedures not followed.	314	5.6%
Patient refused the service/procedure.	311	5.6%
Dilation of Right Ureter with Intraluminal Device, Endo	159	2.9%
Extirpation of Matter from L Int Carotid, Open Approach	152	2.7%
Respiratory Ventilation, 24-96 Consecutive Hours	125	2.2%
Dilation of 1 Cor Art with Drug-elut Intra, Perc Approach	123	2.2%
Drainage of Stomach with Drainage Device, Via Opening	117	2.1%
Extirpation of Matter from R Int Carotid, Open Approach	108	1.9%
Measure Cardiac Sampl & Pressure, Bilateral, Perc	96	1.7%
Other values (112)	3746	67.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
of	2995	7.6%
approach	1603	4.1%
the	1139	2.9%
with	1061	2.7%
open	948	2.4%
perc	883	2.2%
endo	836	2.1%
excision	513	1.3%
not	487	1.2%
dilation	407	1.0%
Other values (327)	28594	72.5%

Most occurring characters

Value	Count	Frequency (%)
	33984	11.8%
e	25696	8.9%
o	20938	7.3%
r	20155	7.0%
t	19985	6.9%
i	18332	6.4%
n	17708	6.2%
a	16792	5.8%
s	11018	3.8%
c	10791	3.8%
Other values (53)	92349	32.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	218593	76.0%
Space Separator	33984	11.8%
Uppercase Letter	25059	8.7%
Other Punctuation	8074	2.8%
Decimal Number	1044	0.4%
Dash Punctuation	859	0.3%
Open Punctuation	60	< 0.1%
Close Punctuation	60	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	25696	11.8%
o	20938	9.6%
r	20155	9.2%
t	19985	9.1%
i	18332	8.4%
n	17708	8.1%
a	16792	7.7%
s	11018	5.0%
c	10791	4.9%
p	9544	4.4%
Other values (16)	47634	21.8%

Uppercase Letter

Value	Count	Frequency (%)
P	3073	12.3%
A	2773	11.1%
C	2226	8.9%
E	2128	8.5%
D	1783	7.1%
O	1520	6.1%
R	1520	6.1%
I	1433	5.7%
V	1266	5.1%
T	1119	4.5%
Other values (12)	6218	24.8%

Other Punctuation

Value	Count	Frequency (%)
,	4217	52.2%
.	1802	22.3%
/	1707	21.1%
'	208	2.6%
&	140	1.7%

Decimal Number

Value	Count	Frequency (%)
6	301	28.8%
9	238	22.8%
2	221	21.2%
4	161	15.4%
1	123	11.8%

Space Separator

Value	Count	Frequency (%)
	33984	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	859	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	60	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	60	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	243652	84.7%
Common	44096	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	25696	10.5%
o	20938	8.6%
r	20155	8.3%
t	19985	8.2%
i	18332	7.5%
n	17708	7.3%
a	16792	6.9%
s	11018	4.5%
c	10791	4.4%
p	9544	3.9%
Other values (38)	72693	29.8%

Common

Value	Count	Frequency (%)
	33984	77.1%
,	4217	9.6%
.	1802	4.1%
/	1707	3.9%
-	859	1.9%
6	301	0.7%
9	238	0.5%
2	221	0.5%
'	208	0.5%
4	161	0.4%
Other values (5)	398	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	287748	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	33984	11.8%
e	25696	8.9%
o	20938	7.3%
r	20155	7.0%
t	19985	6.9%
i	18332	6.4%
n	17708	6.2%
a	16792	5.8%
s	11018	3.8%
c	10791	3.8%
Other values (53)	92349	32.1%

PLACE_OF_SERVICE_CODE
Categorical

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

23	2750
22	904
99	766
11	669
21	482

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	11142
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	21
2nd row	23
3rd row	23
4th row	99
5th row	99

Common Values

Value	Count	Frequency (%)
23	2750	49.4%
22	904	16.2%
99	766	13.7%
11	669	12.0%
21	482	8.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
23	2750	49.4%
22	904	16.2%
99	766	13.7%
11	669	12.0%
21	482	8.7%

Most occurring characters

Value	Count	Frequency (%)
2	5040	45.2%
3	2750	24.7%
1	1820	16.3%
9	1532	13.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	11142	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5040	45.2%
3	2750	24.7%
1	1820	16.3%
9	1532	13.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	11142	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	5040	45.2%
3	2750	24.7%
1	1820	16.3%
9	1532	13.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11142	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	5040	45.2%
3	2750	24.7%
1	1820	16.3%
9	1532	13.7%

REVENUE_CENTER_CODE
Real number (ℝ)

Distinct	100
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	405.32382

Minimum	23
Maximum	983
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	23
5-th percentile	258
Q1	300
median	307
Q3	460
95-th percentile	730
Maximum	983
Range	960
Interquartile range (IQR)	160

Descriptive statistics

Standard deviation	162.27526
Coefficient of variation (CV)	0.40035954
Kurtosis	1.6162923
Mean	405.32382
Median Absolute Deviation (MAD)	36
Skewness	1.4961746
Sum	2258059
Variance	26333.259
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	990	17.8%
301	810	14.5%
636	354	6.4%
305	265	4.8%
420	251	4.5%
510	234	4.2%
450	232	4.2%
250	198	3.6%
730	153	2.7%
320	116	2.1%
Other values (90)	1968	35.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23	3	0.1%
200	8	0.1%
214	1	< 0.1%
250	198	3.6%
251	10	0.2%
255	5	0.1%
258	57	1.0%
259	3	0.1%
260	64	1.1%
270	54	1.0%

Value	Count	Frequency (%)
983	1	< 0.1%
982	1	< 0.1%
981	6	0.1%
975	1	< 0.1%
972	3	0.1%
964	1	< 0.1%
960	1	< 0.1%
943	58	1.0%
942	2	< 0.1%
940	15	0.3%

DISCHARGE_DISPOSITION_CODE
Real number (ℝ)

Distinct	13
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4281099

Minimum	0
Maximum	70
Zeros	20
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	6
Maximum	70
Range	70
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.4463531
Coefficient of variation (CV)	2.6548853
Kurtosis	46.729085
Mean	2.4281099
Median Absolute Deviation (MAD)	0
Skewness	6.4264785
Sum	13527
Variance	41.555468
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	4838	86.8%
6	289	5.2%
30	133	2.4%
3	113	2.0%
2	64	1.1%
4	46	0.8%
62	28	0.5%
7	26	0.5%
0	20	0.4%
9	8	0.1%
Other values (3)	6	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20	0.4%
1	4838	86.8%
2	64	1.1%
3	113	2.0%
4	46	0.8%
6	289	5.2%
7	26	0.5%
9	8	0.1%
30	133	2.4%
50	1	< 0.1%

Value	Count	Frequency (%)
70	1	< 0.1%
62	28	0.5%
51	4	0.1%
50	1	< 0.1%
30	133	2.4%
9	8	0.1%
7	26	0.5%
6	289	5.2%
4	46	0.8%
3	113	2.0%

MEDICARE_STATUS
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

10	4327
20	1075
0	169

Length

Max length	2
Median length	2
Mean length	1.9696643
Min length	1

Characters and Unicode

Total characters	10973
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	20
2nd row	10
3rd row	10
4th row	10
5th row	20

Common Values

Value	Count	Frequency (%)
10	4327	77.7%
20	1075	19.3%
0	169	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
10	4327	77.7%
20	1075	19.3%
0	169	3.0%

Most occurring characters

Value	Count	Frequency (%)
0	5571	50.8%
1	4327	39.4%
2	1075	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5571	50.8%
1	4327	39.4%
2	1075	9.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	10973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5571	50.8%
1	4327	39.4%
2	1075	9.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5571	50.8%
1	4327	39.4%
2	1075	9.8%

ADMIT_SOURCE_CODE
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

2	1980
4	1805
1	1786

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5571
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	2
3rd row	4
4th row	4
5th row	2

Common Values

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

Most occurring characters

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5571	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	5571	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1980	35.5%
4	1805	32.4%
1	1786	32.1%

ADMIT_TYPE_CODE
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	87.0 KiB

1	2127
3	1735
2	1709

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5571
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	1
3rd row	1
4th row	3
5th row	3

Common Values

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

Most occurring characters

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5571	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	5571	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	2127	38.2%
3	1735	31.1%
2	1709	30.7%

MS_DRG
Real number (ℝ)

Distinct	33
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	372.53294

Minimum	42
Maximum	920
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	87.0 KiB

Quantile statistics

Minimum	42
5-th percentile	149
Q1	247
median	309
Q3	442
95-th percentile	872
Maximum	920
Range	878
Interquartile range (IQR)	195

Descriptive statistics

Standard deviation	206.44995
Coefficient of variation (CV)	0.55417906
Kurtosis	0.84743287
Mean	372.53294
Median Absolute Deviation (MAD)	104
Skewness	1.1810481
Sum	2075381
Variance	42621.584
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
442	375	6.7%
205	271	4.9%
292	267	4.8%
176	243	4.4%
233	227	4.1%
309	226	4.1%
202	216	3.9%
291	210	3.8%
683	206	3.7%
149	206	3.7%
Other values (23)	3124	56.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42	120	2.2%
69	105	1.9%
149	206	3.7%
176	243	4.4%
202	216	3.9%
205	271	4.9%
233	227	4.1%
247	110	2.0%
264	37	0.7%
280	140	2.5%

Value	Count	Frequency (%)
920	147	2.6%
872	138	2.5%
871	157	2.8%
690	73	1.3%
683	206	3.7%
641	135	2.4%
603	85	1.5%
481	112	2.0%
470	157	2.8%
442	375	6.7%

Auto

Heatmap
Table

	APPROVED_CHARGE	REASON_CODE	Age	SERVICE_UNIT_QUANTITY	TOTAL_CHARGES	REVENUE_CENTER_CODE	DISCHARGE_DISPOSITION_CODE	MS_DRG	BILL_TYPE_CODE	GENDER	RACE	STATE	PRESENT_ON_ADMIT	DUAL_STATUS	ENCOUNTER_TYPE	CLAIM_STATUS	PAYERS	DENIAL_CATEGORY	PLACE_OF_SERVICE_CODE	MEDICARE_STATUS	ADMIT_SOURCE_CODE	ADMIT_TYPE_CODE
APPROVED_CHARGE	1.000	-0.301	0.056	0.416	0.935	0.142	0.374	0.048	0.315	0.165	0.134	0.279	0.145	0.134	0.123	0.211	0.000	0.092	0.154	0.111	0.124	0.124
REASON_CODE	-0.301	1.000	-0.009	-0.158	-0.085	0.104	-0.127	-0.017	0.081	0.000	0.000	0.055	0.046	0.141	0.017	0.894	0.000	0.502	0.026	0.012	0.013	0.032
Age	0.056	-0.009	1.000	0.035	0.071	0.013	0.099	-0.057	0.158	0.171	0.138	0.369	0.161	0.185	0.174	0.107	0.000	0.120	0.167	0.703	0.182	0.189
SERVICE_UNIT_QUANTITY	0.416	-0.158	0.035	1.000	0.401	0.024	0.226	0.044	0.038	0.000	0.050	0.000	0.044	0.000	0.014	0.004	0.000	0.000	0.028	0.017	0.018	0.000
TOTAL_CHARGES	0.935	-0.085	0.071	0.401	1.000	0.145	0.365	0.059	0.317	0.167	0.135	0.281	0.145	0.136	0.123	0.208	0.000	0.091	0.151	0.113	0.129	0.128
REVENUE_CENTER_CODE	0.142	0.104	0.013	0.024	0.145	1.000	0.030	0.032	0.246	0.063	0.052	0.123	0.056	0.067	0.058	0.234	0.020	0.113	0.059	0.066	0.051	0.086
DISCHARGE_DISPOSITION_CODE	0.374	-0.127	0.099	0.226	0.365	0.030	1.000	0.132	0.424	0.155	0.174	0.233	0.051	0.096	0.070	0.050	0.034	0.017	0.036	0.038	0.093	0.086
MS_DRG	0.048	-0.017	-0.057	0.044	0.059	0.032	0.132	1.000	0.185	0.189	0.126	0.388	0.181	0.164	0.159	0.063	0.012	0.031	0.153	0.155	0.143	0.168
BILL_TYPE_CODE	0.315	0.081	0.158	0.038	0.317	0.246	0.424	0.185	1.000	0.146	0.248	0.270	0.184	0.190	0.222	0.188	0.029	0.079	0.206	0.139	0.185	0.174
GENDER	0.165	0.000	0.171	0.000	0.167	0.063	0.155	0.189	0.146	1.000	0.145	0.406	0.073	0.218	0.215	0.000	0.017	0.000	0.158	0.084	0.092	0.178
RACE	0.134	0.000	0.138	0.050	0.135	0.052	0.174	0.126	0.248	0.145	1.000	0.331	0.117	0.150	0.150	0.000	0.026	0.000	0.134	0.166	0.074	0.169
STATE	0.279	0.055	0.369	0.000	0.281	0.123	0.233	0.388	0.270	0.406	0.331	1.000	0.414	0.382	0.361	0.146	0.071	0.065	0.368	0.360	0.440	0.399
PRESENT_ON_ADMIT	0.145	0.046	0.161	0.044	0.145	0.056	0.051	0.181	0.184	0.073	0.117	0.414	1.000	0.218	0.153	0.072	0.000	0.049	0.129	0.113	0.144	0.107
DUAL_STATUS	0.134	0.141	0.185	0.000	0.136	0.067	0.096	0.164	0.190	0.218	0.150	0.382	0.218	1.000	0.202	0.127	0.017	0.121	0.199	0.188	0.181	0.200
ENCOUNTER_TYPE	0.123	0.017	0.174	0.014	0.123	0.058	0.070	0.159	0.222	0.215	0.150	0.361	0.153	0.202	1.000	0.066	0.018	0.033	0.742	0.114	0.131	0.159
CLAIM_STATUS	0.211	0.894	0.107	0.004	0.208	0.234	0.050	0.063	0.188	0.000	0.000	0.146	0.072	0.127	0.066	1.000	0.000	1.000	0.075	0.023	0.000	0.031
PAYERS	0.000	0.000	0.000	0.000	0.000	0.020	0.034	0.012	0.029	0.017	0.026	0.071	0.000	0.017	0.018	0.000	1.000	0.000	0.009	0.000	0.000	0.015
DENIAL_CATEGORY	0.092	0.502	0.120	0.000	0.091	0.113	0.017	0.031	0.079	0.000	0.000	0.065	0.049	0.121	0.033	1.000	0.000	1.000	0.044	0.012	0.000	0.035
PLACE_OF_SERVICE_CODE	0.154	0.026	0.167	0.028	0.151	0.059	0.036	0.153	0.206	0.158	0.134	0.368	0.129	0.199	0.742	0.075	0.009	0.044	1.000	0.103	0.161	0.581
MEDICARE_STATUS	0.111	0.012	0.703	0.017	0.113	0.066	0.038	0.155	0.139	0.084	0.166	0.360	0.113	0.188	0.114	0.023	0.000	0.012	0.103	1.000	0.074	0.022
ADMIT_SOURCE_CODE	0.124	0.013	0.182	0.018	0.129	0.051	0.093	0.143	0.185	0.092	0.074	0.440	0.144	0.181	0.131	0.000	0.000	0.000	0.161	0.074	1.000	0.080
ADMIT_TYPE_CODE	0.124	0.032	0.189	0.000	0.128	0.086	0.086	0.168	0.174	0.178	0.169	0.399	0.107	0.200	0.159	0.031	0.015	0.035	0.581	0.022	0.080	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	APPROVED_CHARGE	REASON_CODE	Age	SERVICE_UNIT_QUANTITY	TOTAL_CHARGES	BILL_TYPE_CODE	HCPCS_CODE	GENDER	RACE	STATE	COUNTY	CODE	PRESENT_ON_ADMIT	DUAL_STATUS	ENCOUNTER_TYPE	CLAIM_STATUS	PAYERS	DENIAL_CATEGORY	PROCEDURE_CODE	PROCEDURE_DESCRIPTION	PLACE_OF_SERVICE_CODE	REVENUE_CENTER_CODE	DISCHARGE_DISPOSITION_CODE	MEDICARE_STATUS	ADMIT_SOURCE_CODE	ADMIT_TYPE_CODE	MS_DRG
0	44.62	22.0	38	1	225.62	131	82306	male	white	North Carolina	Cherokee	G9340	Y	5	Acute Inpatient	Denied	Medicare	Eligibility	0RGA071	Charges do not meet qualifications for emergent/urgent care.	21	300	1	20	4	3	683
1	1457.06	27.0	84	10	1638.06	131	J1644	female	white	Utah	Summit	E1142	0	0	Other	Denied	Medicare	Coding Error	0W3P8ZZ	Processed in Excess of charges.	23	636	1	10	2	1	470
2	254.95	74.0	81	1	326.95	131	76642	female	white	Delaware	New Castle	I480	0	4	Emergency Department	Denied	Humana	Prior Authorization	0D9670Z	Lifetime benefit maximum has been reached for this service/benefit category.	23	402	1	10	4	1	641
3	4.09	32.0	92	1	76.09	131	85610	male	white	Connecticut	Fairfield	I10	0	2	Other	Denied	Medicare	Benefit Exhausted	4A023N7	ESRD network support adjustment.	99	300	1	10	4	3	378
4	56.11	8.0	69	1	173.11	131	G0463	male	white	Iowa	Pottawattamie	I255	0	7	Other	Denied	Cigna	Coding Error	06BQ4ZZ	The procedure code is inconsistent with the provider type/specialty (taxonomy).	99	510	1	20	2	3	312
5	56.86	14.0	92	1	386.86	131	80053	male	white	Connecticut	Fairfield	M1991	0	2	Other	Denied	Humana	Eligibility	4A023N7	This care may be covered by another payer per coordination of benefits.	99	301	1	10	4	3	378
6	157.42	18.0	92	1	250.42	131	71275	male	white	Connecticut	Fairfield	D125	0	2	Other	Denied	Cigna	Eligibility	4A023N7	Expenses incurred prior to coverage.	99	352	1	10	4	3	378
7	33.76	111.0	69	1	97.76	131	94760	male	white	Iowa	Pottawattamie	Z86010	0	7	Other	Denied	Cigna	Eligibility	06BQ4ZZ	Patient has not met the required eligibility requirements.	99	460	1	20	2	3	312
8	115.73	22.0	80	1	232.73	131	82306	male	white	California	Madera	I480	0	6	Skilled Nursing Facility	Denied	Aetna	Eligibility	0D9670Z	Charges do not meet qualifications for emergent/urgent care.	11	301	1	10	4	2	683
9	32.48	116.0	83	1	125.48	131	36415	female	white	Texas	Dallas	M069	Y	0	Outpatient	Denied	Humana	Eligibility	0SB20ZZ	Revenue code and Procedure code do not match.	22	300	1	10	4	2	149

	APPROVED_CHARGE	REASON_CODE	Age	SERVICE_UNIT_QUANTITY	TOTAL_CHARGES	BILL_TYPE_CODE	HCPCS_CODE	GENDER	RACE	STATE	COUNTY	CODE	DUAL_STATUS	ENCOUNTER_TYPE	CLAIM_STATUS	PAYERS	DENIAL_CATEGORY	PROCEDURE_CODE	PROCEDURE_DESCRIPTION	PLACE_OF_SERVICE_CODE	REVENUE_CENTER_CODE	DISCHARGE_DISPOSITION_CODE	MEDICARE_STATUS	ADMIT_SOURCE_CODE	ADMIT_TYPE_CODE	MS_DRG
5590	10279.81	1.0	78	1	10279.81	111	Q0511	female	white	Pennsylvania	Delaware	Z1231	6	Outpatient	Approved	Medicare	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	250	6	10	2	1	418
5591	11829.41	1.0	78	6	11829.41	111	A4611	female	white	Pennsylvania	Delaware	Z01810	6	Outpatient	Approved	Cigna	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	270	6	10	2	1	418
5592	10714.01	1.0	78	4	10714.01	111	A4206	female	white	Pennsylvania	Delaware	I10	6	Outpatient	Approved	Medicare	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	272	6	10	2	1	418
5593	5230.11	1.0	78	8	5230.11	111	P2028	female	white	Pennsylvania	Delaware	E039	6	Outpatient	Approved	BCBS	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	300	6	10	2	1	418
5594	11224.21	1.0	78	4	11224.21	111	89250	female	white	Pennsylvania	Delaware	R972	6	Outpatient	Approved	BCBS	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	301	6	10	2	1	418
5595	11224.21	1.0	78	6	11224.21	111	85018	female	white	Pennsylvania	Delaware	R42	6	Outpatient	Approved	Medicare	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	305	6	10	2	1	418
5596	11604.91	1.0	78	2	11604.91	111	87040	female	white	Pennsylvania	Delaware	S92901A	6	Outpatient	Approved	Medicare	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	306	6	10	2	1	418
5597	11224.21	1.0	78	1	11224.21	111	81005	female	white	Pennsylvania	Delaware	F17200	6	Outpatient	Approved	Medicare	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	307	6	10	2	1	418
5598	11439.31	1.0	78	7	11439.31	111	99100	female	white	Pennsylvania	Delaware	E785	6	Outpatient	Approved	Humana	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	370	6	10	2	1	418
5599	10714.01	1.0	78	6	10714.01	111	97530	female	white	Pennsylvania	Delaware	E785	6	Outpatient	Approved	Cigna	NOT_APPLICABLE	0SRC0J9	Replace of R Knee Jt with Synth Sub, Cement, Open Approach	23	420	6	10	2	1	418

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter